/*******************************************************************************
 * Copyright (c) 2010, 2018 西安秦晔信息科技有限公司
 * Licensed under the Apache License, Version 2.0 (the "License");
 *    you may not use this file except in compliance with the License.
 *    You may obtain a copy of the License at
 *
 *       http://www.apache.org/licenses/LICENSE-2.0
 *
 *    Unless required by applicable law or agreed to in writing, software
 *    distributed under the License is distributed on an "AS IS" BASIS,
 *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 *    See the License for the specific language governing permissions and
 *    limitations under the License.
 *******************************************************************************/
package com.qinyeit.serviceapp.quartz.job;

import com.qinyeit.serviceapp.quartz.TriggerDetail;
import com.qinyetech.springstage.core.repository.jdbc.PageNamedParameterJdbcTemplate;
import lombok.extern.slf4j.Slf4j;
import org.quartz.JobExecutionContext;
import org.quartz.JobExecutionException;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.dao.DataAccessException;
import org.springframework.scheduling.quartz.QuartzJobBean;

import javax.annotation.Resource;

/**
 * <p>ClassName: com.qinyeit.serviceapp.quartz.job.CheckStoreJob
 * <p>Function: 演示功能，检查库存任务
 * <p>date: 2018-09-07 17:53
 *
 * @author wuqing
 * @version 1.0
 * @since JDK 1.8
 */

@Slf4j
@TriggerDetail(jobName = "TestDataBaseJob",
        jobGroup = "test",
        cronExpression = "0 0 0/3 * * ?", //0 0 0/3 * * ? *
        description = "数据库连接心跳")
public class TestDataBaseJob extends QuartzJobBean {
    @Autowired
    private PageNamedParameterJdbcTemplate jdbcTemplate;
    @Resource(name = "branchJdbcTemplate")
    private PageNamedParameterJdbcTemplate branchJdbcTemplate;
    @Override
    protected void executeInternal(JobExecutionContext context) throws JobExecutionException {
        log.info("diaodu ceshi ------------------------TestDataBaseJob");
        try {
            jdbcTemplate.getJdbcTemplate().execute("SELECT 1");
        } catch (DataAccessException e) {
           log.error("连锁版数据库连接失败",e);
        }
        try {
            branchJdbcTemplate.getJdbcTemplate().execute("SELECT 1");
        } catch (DataAccessException e) {
            log.error("单店版数据库连接失败",e);
        }
    }
}
